D
Dar
I am having an issue with vlookup. I need to have the
lookup_value change based on what is in a certain cell.
Basically within this worksheet, I can choose a state from
a drop down, it then retrieves data from somewhere on a
server and changes the data within the sheet. This
includes the state name throughout. I want my
lookup_value to change to whatever state pops into a
particulr cell. Is this possible or it there another way
to do this? Here is my formula.
vlookup("Mid-Atlantic",Budget,1,False)
lookup_value change based on what is in a certain cell.
Basically within this worksheet, I can choose a state from
a drop down, it then retrieves data from somewhere on a
server and changes the data within the sheet. This
includes the state name throughout. I want my
lookup_value to change to whatever state pops into a
particulr cell. Is this possible or it there another way
to do this? Here is my formula.
vlookup("Mid-Atlantic",Budget,1,False)