Finding a number one of three columns

[artsyvision]

I have an excel sheet that I need a formula to find the matching number in 3 different columns and come back and tell me which column that number is in by putting a S,F or G.

So in Column D I have the number and on different sheet (called AccountCodes) I have the 3 columns, A (which is what I want to be S), B (which is what I want to be F), and C (which is what I want to be G)

Is there an easy way in excel to do this?

[simarui]

I think this does it...

Please Login or Register  to view this content.

[artsyvision]

That almost worked, but I think it was pulling from the same sheet, and I have the 3 columns in another sheet. I changed it to the below, but that still isn't working. I'm get a #N/A as the result

=IF(MATCH(D3,AccountCodes!A:C)=1,"S",IF(MATCH(D3,AccountCodes!A:C)=2,"F",IF(MATCH(D3,AccountCodes!A:C)=3,"G")))

[simarui]

Try:

Please Login or Register  to view this content.

if that doesn't work upload a sample with your broken formula...