LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change value based on another cell's value mainemike Excel Discussion (Misc queries) 1 March 7th 06 06:36 PM
How to change an other cell's value? Nirel Excel Discussion (Misc queries) 1 February 1st 06 11:20 AM
Change a cell's value using a button Ash007 Excel Discussion (Misc queries) 2 March 17th 05 03:01 PM
How can I change a text to a cell's address? Antônio Sobral Excel Discussion (Misc queries) 0 February 15th 05 04:55 PM
How to change a single cell's width TemporarilyConfused Excel Worksheet Functions 2 November 10th 04 07:36 PM


All times are GMT +1. The time now is 08:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"