Look for an excel formula

  • Thread starter Thread starter pauledouf
  • Start date Start date
P

pauledouf

Hi,



I Have 2 worksheets,
Worksheet 1 with all the daily input of my project

I have 3 diferents types of input (column A)
E, S, and H input, for exemple : E174, H014, S007

each of them correspond to a description (colomn B)

In the Worksheet 2, I only have the S and H Input with another column
(B) which contains the name of the supplier of the item.

I would like to report in an new column (C) in the worksheet 1, the
name of the supplier corresponding to the S and H numbers I have.(from
the worksheet 2)
And if there is no supplier (for the E input) i would like to write
"EIS" in the cell.

How can I do that?

I will find the file here :
http://jempenhap.free.fr/excel_help/excel_help.zip

thank u very much in advance
PAul
 
Hi

=IF(ISNA(VLOOKUP(A8,'2'!$B$7:$D$68,3,FALSE)),"EIS",VLOOKUP(A8,'2'!$B$7:$D$68
,3,FALSE))

in Cell C8 of worksheet '1' and filled down should give you what you are
after.

Hope this helps

Cheers
JulieD
PS i personally would range name the area '2'!$B$7:$D$68 and make it a
dynamic range as per Debra's notes at
http://www.contextures.com/xlNames01.html#Dynamic
 
Hi
try the following in C1 on your first sheet
=IF(ISNA(VLOOKUP(A1,'sheet2'!$A$1:$B$1000,2,0)),"EIS",VLOOKUP(A1,'sheet
2'!$A$1:$B$1000,2,0))
and copy down
 
Back
Top