Hi guys,
I have the following formula which matches values from an adjacent column, but need it to look at a different column
The formula is
It looks at column A and finds the value in adjacent column B....can anyone tell me how I adjust this to match the adjacent column F instead of B??
I thought it was just a case of changing the bit at the end from a1:b100 to a1:f100, but this makes no difference??
Any ideas?
thanks
I have the following formula which matches values from an adjacent column, but need it to look at a different column
The formula is
Code:
=IF(ISNUMBER(MATCH(B22,INDIRECT("'query"&B24&"'!A1:A100"),0)),VLOOKUP(B22,INDIRECT("'query"&B24&"'!a1:b100"),2,0),"")
It looks at column A and finds the value in adjacent column B....can anyone tell me how I adjust this to match the adjacent column F instead of B??
I thought it was just a case of changing the bit at the end from a1:b100 to a1:f100, but this makes no difference??
Any ideas?
thanks