• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Multiple vlookup

P

pallu

Member
Hi

I have tried for multiple vlookup in different sheet but unable to get result it shown as#NA error, please help me out.



=IF(VLOOKUP(A7,'Fuel and Driver less than 13'!B4:AJ211,35,0)=0"",(VLOOKUP(A7,'Fuel 13 and above'!B5:AI45,34,0)))
 
Hi

There is a comma missing in your formula
=IF(VLOOKUP(A7,'Fuel and Driver less than 13'!B4:AJ211,35,0)=0,"",(VLOOKUP(A7,'Fuel 13 and above'!B5:AI45,34,0)))

highlighted in red.

Thanks
 
Without seeing your spread sheet it is difficult to comment further, the formula looked alright to me at first glance.

Thanks
 
Or try,

=IFERROR(IFERROR(VLOOKUP(A7,'Fuel and Driver less than 13'!B4:AJ211,35,0),VLOOKUP(A7,'Fuel 13 and above'!B5:AI45,34,0)),"")

Regards
 
Hii,

please remove open bracket . highlighted in red mark

=IF(VLOOKUP(A7,'Fuel and Driver less than 13'!B4:AJ211,35,0)=0"",
( VLOOKUP(A7,'Fuel 13 and above'!B5:AI45,34,0)))


RECTIFIED FORMULA
=IF(VLOOKUP(A7,'Fuel and Driver less than 13'!B4:AJ211,35,0)=0,"",VLOOKUP(A7,'Fuel 13 and above'!B5:AI45,34,0))

thanks
rahul
 
You must log in or register to reply here.
Back
Top