Vlookup

Verb

Hi all


What am I typing wrong here


=VLOOKUP(AQ4,'Min Max List'!$A$2:$A$1000,B,FALSE)


I want this formula to look into Min Max List (which is a different tab in same document)


Match what is in AQ4 (AQ4 is just has a number I type in, this is to look for the number in column A on Min Max List tab)


Display what is adjacent to AQ4 (for example 1 which relates to line 1) is in column 2 (or




This is my first VLOOKUP attempt

GunJack

replace B with 2 and false with 0 (that's a zero) and you should be there or thereabouts

bingo_bango

The column number needs to be the column containing the required value. Column 1 will just return the lookup value.

If you are not getting an expected answer, then I would suggest that you look at making sure the format of both Column A in the lookup array and AQ4 are the same format. It's likely that one is formatted as a number and the other as general (or some variation of that). Once confirmed that both are the same, then focus on the cell with the formula and hit Enter. This should (hopefully!) return the correct value.

Edit: I've just realised that the lookup array you specified is only one column. You need the array to cover ALL data in Min Max List.

=VLOOKUP(AQ4,'Min Max List'!$A$2:$AQ$1000,2,FALSE)

where AQ is the last column of data in that sheet.

Ainsley1

Did you get an acceptable answer to your other recent Excel thread?
It would be courteous to post to it for all those who have tried to help.....