Thread: How do I combine If and VLookup function?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Felicia Pickett
 
Posts: n/a
Default How do I combine If and VLookup function?

I have a vendor name in Sheet 1, Cell A1 and a corresponding Vendor Number
in Sheet 1, cell C1. On Sheet 2, I have a Vendor name in cell A1 and
corresponding Vendor number in a cell C1 and the name I would like to use in
cell B1.

How do I get the B1 information from Sheet 2 to Sheet 1 by matching the
information on both?
Sheet 1
A1 = Accuflow
C1 = 15010427

Sheet 2
A1 = Accuflow
B1 = Accu
C1 = 15010427
Reply With QuoteReply With Quote