if and VLOOKUP formula help

[DIMWIT]

Hi

I have been wracking my tiny brain all day and cannot figure out what I am doing wrong.

Basically my formula needs to do the following:

lookup a value in a set column according to ID number and if this is blank to leave blank and do nothing else,
if not blank to lookup another column value and based on this value (0 or 1) perform another lookup

My formula is:

=IFERROR(IF(VLOOKUP($B7,Primary,J$2,FALSE)="","",IF($AH7=0,VLOOKUP($B7,Primary,J$3,FALSE),VLOOKUP($B7,Primary,J$126,FALSE))),"")

The formula brings out the correct data but the first condition, if its blank then leave as blank and do nothing else is being ignored.

Any clues?

 

[Latchmaker]

I notice that your vlookup is too a specific cell not a range do you want to look at the entire column of J or just the specific cells J2, J3 and J126

Or is Primary a listed range of cells?

Try this replace ranges as needed.

=IF(VLOOKUP(L1,A:B,2,0)="","",VLOOKUP(VLOOKUP(L1,A:B,2,0),F:G,2,0))

 

[DIMWIT]

Hi , its looking at the Primary worksheet and is looking at a specific cell. This cell denotes the relevant column in the Primary Worksheet

so for example for ID 2236 look up the value in column 23.

 

[AkaTrouble]

not sure if maybe putting the VLOOKUP in its own set of brackets might return the result to test if = "" (nothing)

untested

=IFERROR(IF([COLOR=#ff0000]([/COLOR]VLOOKUP($B7,Primary,J$2,FALSE)[COLOR=#ff0000])[/COLOR]="","",IF($AH7=0,VLOOKUP($B7,Primary,J$3,FALSE),VLOOKUP($B7,Primary,J$126,FALSE))),"")

 

[DIMWIT]

Have tried the extra brackets but no change

 

[DIMWIT]

Hi guys, managed to figure out why it wasn't working. thanks for your replies