Thread: vlookup lookup_value
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
  
Posts: 1,231
Default vlookup lookup_value
"Bob Phillips" wrote...
Sounds like Prices key column is text. Fix that or use

=VLOOKUP(TEXT(C22,"@"),Prices,2,FALSE)
....

Or replace TEXT(C22,"@") with C22&"".


Reply With QuoteReply With Quote