How do I get info from a cell based on criteria from another cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Which function do I use to get a value in sheet 2, column C, where the
criteria is in Sheet 2 column A? On Sheet 1 are 2 columns which I want to
draw the information from. For Example: On sheet 1, Column A, is the name
of the Aisle. On Sheet 1 Column B is the # that needs to be generated on
sheet 2. On Sheet 2 there are 3 columns. When the Aisle name in Column A
is entered, I need the # to appear in column C (Sheet 2). F.Y.I, the Aisle
name and # are in the same row on Sheet 1. Can you help me?
 
VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
assuming you select or type your ailse name in sheet 2 a1
then the formula(s) on sheet 2 is=VLOOKUP(A1,Sheet1!A1:B6,2,FALSE).where
sheet1!A1:B6 is substituted by your two column range with your ailse and
#,the 2 represents the second column in your lookup table (the # column) and
the false is a value that tells vlookup to look for an exact ailse match

paul
remove nospam for email addy!
 
You must log in or register to reply here.

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

Look-up 3
Update cell value based on name and specific date 1
Match and delete rows on two different sheets from reference numbers 4
How to add data from cells based on different criterias? 2
Subtracting based on 2 conditions 3
Need VLOOKUP to Work Two Ways 0
Excel VBA to move cells to sheet2 based on selection in sheet1 0
Copy corresponding cell in Column B if cell in A contains certain text? 1

Back
Top