Hi there
I need the final hint for the good formular
Attached is a sample file, I am working on.
I need to perform the following logical tests:
1) Material
Tab "Abfrageliste" the cell in column B needs to match with the cell in tab "Suchliste" column D
AND
2) Quantity
Tab "Abfrageliste" the cell in column D needs to match with the cell in tab "Suchliste" column C
AND
3) Position
Tab "Abfrageliste" the cell in column E needs to match with the cell in tab "Suchliste" column B
All 3 logical matches needs to be in the same row.
If YES, then I need the result of tab "Suchliste" column A copied in tab "Abfrageliste" A
If NO, result should be "ERROR"
I tried a couple of IF / AND formulars, but I never got the required result
Thanks a lot for looking into it and sharing your experience
Jan
Bookmarks