vlookup if not found try another vlookup

Powerful Penguin answered on May 14, 2020 Popularity 4/10 Helpfulness 1/10

answer vlookup if not found try another vlookup

Comment

=IFERROR(VLOOKUP(A2,'Sheet1'!$A$2:$A$1932,1,FALSE),VLOOKUP(B2,'Sheet1'!$A$2:$A$1932,1,FALSE))

Popularity 4/10 Helpfulness 1/10 Language whatever

Tags: vlookup whatever

Link to this answer
Share Copy Link

Contributed on May 14 2020

Powerful Penguin

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

Oops, You will need to install Grepper and log-in to perform this action.