vlookup, refer second and return third without helper cells

[Nova1979]

Hello ladies and gents,

I am sure this has been asked a thousand time.

This formula is placed in BAG3:AS and then copied down

=VLOOKUP(D2,AABD!D:G,4,FALSE). If found, this then needs to check the relative row in AABD:G for SV (text specific), if true, return the value in that same row (number) in AABD:I

This formula as mentioned above will be placed in BAG3:AS

Any help is appreciated

Thanks

 

[etaf]

=VLOOKUP(D2,AABD!D:G,4,FALSE). If found, this then needs to check the relative row in AABD:G for SV (text specific

Vlookup is looking down column D to match D2 for a value in column G, the 4 in the vlookup , so then you want to look again at column G for SV ?
which unless d2 is SV , then it wont be true - AM i missing something ?

 

[Fluff]

Maybe

=IF(VLOOKUP(D2,AABD!D:G,4,FALSE)="SV",VLOOKUP(D2,AABD!D:I,5,FALSE),"")

 

[Nova1979]

Sorry it’s taken so long to reply.
Fluffs formula works for me
Thanks for both of your input

 

[Fluff]

Glad we could help & thanks for the feedback.