Thread: How can I use "VLOOKUP" with cells containing both Text & Numbers?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Brentp97
 
Posts: n/a
Default How can I use "VLOOKUP" with cells containing both Text & Numbers?
I am attempting to create a cross reference between 2 spreadsheets. I am
currently using the "VLOOKUP" function to obtain my results. The problem
that I have run into is the values being compared & the desired output can
contain both numbers and text (some only contain numbers). The formula I am
using will work only on numbers. How can I get this to work for a
combination of both text and numbers?
Reply With QuoteReply With Quote