Numbers: vlookup doesn't return text value
Any one guide me How to get Vlookup function to return text value in Mac numbers
VLOOKUP should return whatever type of value you have in the return column(s), as demonstrated with number ad text values below.
The VLOOKUP formula in B2 of T 1 is shown below the table. The formula is filled down from B2 to the last cell in column B.
Copy/Paste version: VLOOKUP(A2,T 2::A:B,2,FALSE)
Lookup table must be named "T 2"
Find values must be in column A. Return values in column B.
If the example does not match your request, please provide a more detailed description of how your situation differs from the example.
Regards,
Barry