elwayisgod
asked on
Excel - VLOOKUP won't return text?
=VLOOKUP(AD15,CUID!$A$1:$A $45,2,FALS E)
AD15=4306889
CUID tab is just two columns. The value 4306889 is in A6. In B6 the text is 'Ace Hardware'. My formula above is returning #REF!
Any ideas? I just want to find the value in AD column in column A of CUID tab and return the text value in corresponding row in Column B on CUID tab.....
AD15=4306889
CUID tab is just two columns. The value 4306889 is in A6. In B6 the text is 'Ace Hardware'. My formula above is returning #REF!
Any ideas? I just want to find the value in AD column in column A of CUID tab and return the text value in corresponding row in Column B on CUID tab.....
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER