Hey Everyone. I am stuck on this formula I created. I want to type an item number into B4 and if it matches, I want the info from column E and G to show in B2 and C2. I have come up with a formula that will show the info from column F, but I cannot figure out how to get the info from column G to show in column C. Any help is appreciated.
Thanks all.
Item Search.xlsx
Like this, in column C?
=IFERROR(VLOOKUP(A6,$D$6:G$602,4,FALSE),"")
You should hit F5, because chances are I've edited this post at least 5 times.
Example of Array Formulas
Click the * below on any post that helped you.Originally Posted by Jacc
Geese, I could have sworn I tried that. Thanks for your help!
I am just curious. Is there a way to do this type of search where the results only show if it is an exact match?
Thanks.
You mean like;
in B
=IFERROR(VLOOKUP(B4,F6:G602,1,0),"")
in C
=IFERROR(VLOOKUP(B4,F6:G602,2,0),"")
?
When you use the "FALSE" argument in the VLOOKUP, it only looks for exact matches.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
His original Vlookup formulas have a lookup_value which references a unique index number, the false in this case doesn't return an exact match because the lookup tables indexes are based on a Rank formula, which looks at another cell with a Search function. The search function is what is generating non-exact results, as it will return values containing any part of the value typed into B4, the Seach input.
Thanks for your help Speshul. I have learned a lot from it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks