Hi all,

I am new to this and need some serious help with my working life. Hope you can help.....please.

I am trying to find a way of looking up values in one worksheet to populate another...... i.e. if a certain value in column A exists in one worksheet match it to a value in a particular column in a second worksheet - then return a corresponding value in another column from one worksheet to another.

I have attempted this using IF statements between the two worksheets, however.... the values being looked for are not always present in the second worksheet. Hence it all falls apart because i'm using specific rows ( I think).
The formuls I'm using looks something like

=IF(A1=Sheet2!A1,Sheet2!B1,"None")

In this specific task I am try to carry out all values possible exist in the first worksheet (the one I am try to populate). There will never be a value I am trying to match in the 2nd worksheet that is not in the first.


E.g.

All values exist in column A of worksheet trying to populate.

Some of these values may not be present in the second worksheet with the corresponding value I am trying to merge.

But the second worksheet will never have any additional values that don't match back to what I am looking for

Hope someone can advise me on what I'm doing wrong

From a distrught and fustrated Welsh lass

Thank you in advance