Capture.PNG
3051126 is Lookup Value and 8924365 Value i need
Can use Vlookup + Match ?
when i Vlookup 3051126 i get "Target"
Capture.PNG
3051126 is Lookup Value and 8924365 Value i need
Can use Vlookup + Match ?
when i Vlookup 3051126 i get "Target"
Try this:
=INDEX($C$1:$C$6,MATCH(B8,$A$1:$A$6,0)+1,0)
where B8 contains the lookup value.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Wow Thank you very much
you save my day
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks