Combination of IF & Vlookup, what will be the syntax ?

[Jyotirmaya]

In my sheet I want that IF H5 of Backend sheet will be matched with some text of D5 then it will search in a range of Data sheet.

I am trying for code that

=VLOOKUP(H5,IF(D5="CAR", ???? then it should search a range from the DATA sheet for the H5 if the D5 matches with text "CAR". what should be the code ??

 

[Aladin Akyurek]

The value of H5 is not certain, it will change but the value of H5 is there in the DATA sheet. the value of H5 is there in B column of Data sheet. I want the associated vertical data of D column of DATA sheet. so the normal Vlookup will be like this =VLOOKUP(H5,DATA!A1:F50,4,FALSE) but I want to add the If function, if the D5="CAR" then it will search a different range, then if D5=BIKE then it will search a different range & so on. if D5 not equal to CAR then result may be come zero.

Something like:

=VLOOKUP(H5,INDIRECT(D5),2,0)

This will work if the relevant ranges have been given appropriate names. For example, the range relevant for CAR should be name CAR, BIKE etc. Would this work for you?