IF and LOOKUPs

[Cmorgan]

Evening,

I use the following formulas for Lookups:

=IFERROR(VLOOKUP(G5,LOOKUPS!$AG$19:$AH$218,2),"")

However I would like to amend this so I have a single formula that:

1. Looks in cell A5 and if H is the value then uses =IFERROR(VLOOKUP(G5,LOOKUPS!$AG$19:$AH$218,2),"")
2. However if instead in cell A5 F is the value then it uses =IFERROR(VLOOKUP(G5,LOOKUPS!$AS$19:$AT$218,2),"")

Any help combining these two formulas to do this would be greatly appreciated.

Thanks

[AlKey]

Maybe like this

=IFERROR(VLOOKUP(G5,LOOKUPS!$AG$19:$AH$218,2),IFERROR(VLOOKUP(G5,LOOKUPS!$AS$19:$AT$218,2),""))

[Cmorgan]

Many thanks but how does it know to check A5 for either the value H or F to decide which lookup to use?

[Special-K]

Shouldn't it be this?

=IFERROR(VLOOKUP(G5,IF(A5="H",LOOKUPS!$AG$19:$AH$218,LOOKUPS!$AS$19:$AT$218),2),"")

[Cmorgan]

Many thanks, I'll give this a go.