Lookup Text Value

N

nuver

Hello
I need to use a lookup to return only a result if the value is text.
have a list of item numbers in row A that are repeated several times.
need to look up the value in column B that corresponds to the ite
number in Column A. There is only one text result in column B for
single instance of the item number, so if the item number is liste
more than once there will be an item number that has no result. Th
issue I am having is that the VLookup returns the first occurence whic
sometimes is nothing. How can I set a VLookup to return a text value?

Thank you for your Help
 
J

Joe Mac

Try this...
Create a named range for the entire Lookup_Range (both
columns A & B below with the respective rows)
Create a named range for the entire Lookup_List (column C
below with the respective rows)
Place the following formula in Col D and copy next to the
respective values in the Lookup_List
=IF(ISNONTEXT(VLOOKUP
(Lookup_List,Lookup_Range,2,TRUE)),,VLOOKUP
(Lookup_List,Lookup_Range,2,TRUE))



Col A Col B Col C Col D
Item # Return Value Lookup List Lookup Values
123 123 test1
123 test1 234 test2
234 test2 235 test3
235 test3 236 test4
236 test4 237 test6
237
237 test6

good luck
 
Top