• 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.

Vlook up with multiple columns.

Dear Sir,

I have my Data in column B and E in SHEET 1,

SHEET 2 have data in column B only.

I want amount from SHEET 1 to SHEET 2 in front of specific heads.

I can apply V LOOKUP only when data has got into one column only.

but in such case where data in there in two column how to apply v lookup.
 

Attachments

  • Vlookup Help.xlsx
    9.7 KB · Views: 4
=IFERROR(VLOOKUP(C2,'Transport Balance Sheet'!$A:$B,2,0),VLOOKUP(C2,'Transport Balance Sheet'!$D$4:$E$215,2,0))
Ref to above formula if name is not avaialble then it shows NA but instead of NA I want to see zero which will help me to calculation.

Can you please advise.
 
Hi ,

Use another IFERROR , as in :

=IFERROR(VLOOKUP(C2,'Transport Balance Sheet'!$A:$B,2,0),IFERROR(VLOOKUP(C2,'Transport Balance Sheet'!$D$4:$E$215,2,0),0))

Narayan
 
Back
Top