Retrieve values between different worksheets with conditions

[elcrazyz]

On Worksheet 1, cell F7 :

> if the value of the cell F6 equals any value from any cell of the column A Worksheet 2 (e.g. A4)

> then, on the same row of this matched value (e.g. A4) in Worksheet 2 :

(1) copy the value of the cell in column C (e.g. C4)

(2) paste this value back in Worksheet 1, cell F7

Can someone help me with this please?

I've made the below formula but it works only for 1 row only. I want to make the formula work for any value of the column like $A$A and $C$C but this doesn't work.

=IF(F6='CLIENTS'!$A$6;'CLIENTS'!$C$6;"")

[Kaper]

Probably

Please Login or Register  to view this content.

should do the job. If not - please see the yellow banner above and attach sample file

[elcrazyz]

Dear Kaper,

Thanks for your answer. I tried your formula but I didn't manage to make it work.

Please find attached the files (emptied with only the necessary elements).

1. Open both files to have links between files working.
2. See below the initial request adapted with those example files.


On FILEA, cell F7 :

> if the value of the cell F6 equals any value from any cell of the column A FILEB (e.g. A4)
> then, on the same row of this matched value (e.g. A4) in FILEB :
(1) copy the value of the cell in column C (e.g. C4)
(2) paste this value back in FILEA, cell F7



Thanks
Simon

[Kaper]

Please Login or Register  to view this content.

and to cover situation of value not found

Please Login or Register  to view this content.

and to retrieve data from column H

Please Login or Register  to view this content.

of course could be also nested within IFERROR

And so on for mrext columns just change $A:$H to proper set of columns and use the last column number as third value in a function

(In a file you nmay need to reenter addresses of used ranges from FILEB)

(PS. You don't have to use absolute addresses (with $ signs), relative adresses, with just letters and numbers would be also fine)

[elcrazyz]

You are absolutely AWESOME !

Thank you so much for your help, this formula is going to save me tons of time.

Cheers

[Kaper]

Glad to hear so

Use the saved time wisely

Please use "thread tools" above to mark this thread SOLVED