IF formula for inserting certain values

[etaver87]

Hi everybody,

I'm trying to use the IF formula in Excel the right way.

So I have column G where I have certain numbers, e.g. 1111

In Column H I have some other value.

How can I use the IF formula, or any other formula that works for that matter, so that if he finds the number in column G22 he copies the value from H22 into the field where I write the formula into?

I thought of:

Please Login or Register  to view this content.

In that case he should give me the number in the cell of column H that is right next to the cell in column G that has the number 101976.

But somehow that doesn't work.

Many thanks for your help.

[tony h]

I think you just need the VLOOKUP function.

What happens if there is no match? You might need an IF to handle that occasion.

[bhenlee]

You can always use VLOOKUP or try this:

=IFERROR(INDEX(H:H,MATCH(109176,G:G,0)),"")