Try the following...

=IF(COUNTIF(SheetB!B1:G100,SheetA!F3),"I","A")

...where SheetA!F3 contains your look up value (you can change that to
which ever cell suits) and Sheet1B!B1:G100 contains your range of data
for your lookup table (change this range accordingly).

Hope this helps!

simplywitt Wrote:
Thanks for your reply however that did not work. I am probably not
explaining myself very well. I wand to write a forumula in spreadsheet
A for cell A3 - I want to lookup value RF05 in spreadsheet B in columns
B - G, if value RF05 exists then I would like to return the value of
"I" if it is found. If it isn't found, return a value of "A" - IS THIS
POSSIBLE?

Spreadsheet A: "RF04" in cell F3
A B C D E F G H
1
2
3 RF05
4
5
6

Spreadsheet B:
A B C D E F G H
1 RF01 RFG3 ST10 SY69 RF05 4G01
2
3
4
5
6


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=320104