Hello,
i have the problem that i can't find the right formula...
I have 2 values in different cells Example under Komponente there are a lot of components there are beginning in the A3 (Mapping Sheet and down with other values) & B1 (and C1 are pinned values).
with this criteria there must insert the right cell that will be find under "Data" sheet in the Mapping sheet cell nr. B3.
The necessary data will be find under Data.
I have tried with two vlookups but doesn't work
i have attached the example file.
I hope i was clear what i need.
Thanks a lot.
Bookmarks