if function

[jdeleon]

new question if d185=c8 then e185= e8
can anyone help

[Jacc]

Put this in E185

Please Login or Register  to view this content.

[Tony Valko]

Entered in E185:

=IF(D185=C8,E8,"")

[jdeleon]

ok that worked what if i want if d185= one of c8 thru c18 then e185 = the same row cell but in the e column
this is hard to explain

[Jonmo1]

Try

=VLOOKUP(D185,C8:E18,3,FALSE)

[jdeleon]

i think you have a typeo in there or im not sure what the 3 stands for

[Jonmo1]

The 3 stands for the 3rd column of the array (C8:E18) = column E

So it finds the match to D185 within C8:C18.
and returns the corresponding value from the 3rd column of the array (E8:E18)

[jdeleon]

wow well then i feel like an idiot for questioning you because it totally worked thanks very much

[Jonmo1]

Great, glad to help.