Excel Query

choyaa

Hi All,


I am working in a locked spreadsheet via which I can't change any of the row/column layout. Within Column G I am trying to input a simple Vlookup formula that searches for a value in column H and returns the corresponding value within a separate tab. This should have been straightforward but I am being returned a #N/A even though there is the corresponding value within tab two.


How can I get around this? Below is my code:


=VLOOKUP(H30,'Tab2'!F4:G77,2,FALSE)

bingo_bango

I'm fairly sure this will be a formatting issue. Check that the values in both the H column and that containing the lookup value are the same.

i.e. if you are looking up a number, ensure the lookup and H columns are both formatted as numbers (use the error checker to convert to numbers).

Also, ensure that the value you are searching is in Column F in Tab 2 (leftmost column).
edit: and that column F in Tab 2 is sorted!

bengalknights

Are the formats the same (try text to columns if using numbers) also include a dollar on F4:G77 so they are static ($F$4:$G$77)