vlookup from a list

L

Lisa

On sheet 1, I have a list of item #'s referenced from sheet 2. I need to
return a cost on an adjacent cell in sheet 1 for the item # looked up.

any ideas?
 
S

Shane Devenshire

Hi,

VLOOKUP(#,List,2,FALSE)

would look up a # in the first column of List and bring back the item in
column 2 if a match is found in column 1.

Cheers,
Shane Devenshire
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
Section and Page numbering 0
trouble with (complicated) vlookup searching another workbook 2
Copy and shift data automaticaly 0
Space at end of multi page list to accommodate new entries 1
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Combine data into central worksheet 1
Excel does not accept text format! 0

Top