Selecting specific data

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

Guest

Hi Guys and Gals

If I have Cells A1 - A20 each having a number from 1 - 20 and then Cells B1 - B20 each represent an item corresponding to that number ie, A1=1, B1=Walls A2=2, B2=Floor and so on. (all on sheet 1)

Now, if on sheet 2 I have a table and in cell A1 of that table I were to enter a number, say 2, how would I get cell B1 to select the correct item corresponding to that item number, ie Floor?
 
One way:

=VLOOKUP(A1,Sheet1!A:B,2,FALSE)


But if your table in Sheet1 just has numbers in sequential order from 1
to N, you could instead ignore the first column and use

=INDEX(Sheet1!B:B,A1)
 
Back
Top