Lookup Text Value

[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

 

[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