variable lookup_value

[dar]

I need help with the vlookup function. Specifically the
lookup_value. I would like the lookup_value to take the
text from a particular cell on the same sheet, and use
that as the lookup_value for my table_array which is on a
different tab. I've tried just typing in the cell
reference, but it returns a #n/a. The text in the cell
that I want it to use, will change based on what text you
choose from a combo box. For example, my formula
currently is vlookup("Mid-Atlantic",budget,2,false). This
formula works fine with hard coding "Mid-Atlantic" into
it. But when I choose "New England" from the combo box,
it still obviously shows the "Mid-Atlantic" info from the
separate tab. I would like it to take whatever text from
cell C11 and use that in the formula to look up the value
on the separate tab. Make sense? Any help would be
greatly appreciated.

 

[Frank Kabel]

Hi
=VLOOKUP(C11,budget,2,false)
should work just fine (if the value in C11 is identical to a value in
your range 'budget'. You may have some spaces or other characters in
cell C11