Hi All,
As enclosed in my worksheet,I am trying to find out the J column items based on by comparing & looking values of F8 from I column in G8.Here ,I am getting an error in G8 on calculation.Where I am wrong ?
Can any assist me.
With Best Rgds,
Suresh
hi Suresh. by not putting in FALSE, typing TRUE or 1, you will be looking for approximate match. and that should be what you are doing:
=VLOOKUP(F8,I5:J7,2)
you failed because putting FALSE is looking for an exact match & there is no 139 in I5:I7
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Try this:
=VLOOKUP(F8,I5:J7,2,1)
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
You're welcome and thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks