View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Vangelo Vangelo is offline
external usenet poster
 
Posts: 4
Default CHANGE ONE CELL'S VALUE AND GET THE SAME RETURN - SOME HELP PLEASE

Here is my issue;

when I write this IF(F11=6,VLOOKUP(G15,'2 5 6 '!A7:B181,2,FALSE) it works
just fine, but I want to be able to change F11 from 6 to 2 in the cell, and
the rest should be the same result.
So what I want is to be able to write: if F11=6 or F11=2 and get the same in
return.
I just want to be able to change the 6 to 2 to cell F11 and be able to get
the same answer in return.
'2 5 6' is the sheet where I have the range of data to VLOOK to in 2 columns.

I know that exel can afford only 6 nested if, but I filled them all up so I
need some more...
SOME HELP PLEASE