If function is limiting me at 7!!

  • Thread starter Thread starter 4bigfoot
  • Start date Start date
4

4bigfoot

I am trying to return a number if it matches with the IF function to
certain number in " ". However I can only get seven possibilities an
I need 30.

I would like to write a formula that once a "number" is typed in th
cell to the left of it, it searches a column off the page until i
finds that "number" and enters the cell next to it on the right.

So formula is in B1, number I am searching for a match is "88" in A1.
It searches in Column W1:W100 untill it finds "88" in W88 and enter m
"name" which is in X88 right next to it. Each number will have
certain name next to it. Goal is to have the name of that person i
the formula cell, by entering a two digit number.

I'm sure it is easy but I am new to excell. Thank

Attachment filename: book1.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=40441
 
4bigfoot > said:
I am trying to return a number if it matches with the IF function to a
certain number in " ". However I can only get seven possibilities and
I need 30.

I would like to write a formula that once a "number" is typed in the
cell to the left of it, it searches a column off the page until it
finds that "number" and enters the cell next to it on the right.

So formula is in B1, number I am searching for a match is "88" in A1.
It searches in Column W1:W100 untill it finds "88" in W88 and enter my
"name" which is in X88 right next to it. Each number will have a
certain name next to it. Goal is to have the name of that person in
the formula cell, by entering a two digit number.

I'm sure it is easy but I am new to excell. Thanks
Click to expand...

=VLOOKUP(A1,W1:X100,2,0)
 
You might also want to look at Data Validation, which can stop an invalid
value being entered.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top