Good Morning Everyone,
In Sheet1, I have cell A2 with 14 numbers(22711076900772) in it. In cell B2 I use (=LEFT(D2,3)) which returns a value of 227.
I want cell C2 to return a value from Sheet2, column B(2) based on the value in cell B2, Sheet1.
IFERROR(VLOOKUP(Sheet1!B2,'Sheet2'!$A$1:$A$2,2,FALSE),0)
What am I missing here?
Thanks,
Dean
Like this ?
=IFERROR(VLOOKUP(B1+0,$Sheet2!A1:B2,2,0),0)
Try:Formula:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Formula:Please Login or Register to view this content.
3 issues:
- Where is 2nd column for VLOOKUP? You declare A:A it means only 1 column.
- you are looking for B2 which is empty.
- number vs. text
Change B2 for (B1*1) and change for A:B and should be fine
Last edited by KOKOSEK; 02-05-2019 at 12:02 PM.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
Thanks Everyone!!
Just so I understand, what does the (+0) represent?
Thanks,
Dean
Same idea as *1 'convert' text which looks like number into number
The LEFT function returns a "text string number". To convert to a number any arithmetic operation does the trick
Thanks again!
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks