Find text and add two different texts next to cell

Closed
Vega - Aug 3, 2015 at 01:40 PM
TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen October 4, 2022 - Aug 6, 2015 at 11:36 AM
Hello,

I have a sheet with contractor names(sheet1) on A1 and I have a separate sheet (sheet2) with contractor names (A1), personnel assigned to that contractor (B1) and team those personnel belong to (C1).

Im trying to write a formula where it searches sheet1 and if condition on sheet2 is met, then adds B1 and C1 data from sheet2.

Thank you allllll in advance!

1 reply

TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen October 4, 2022 523
Aug 6, 2015 at 11:36 AM
Hi Vega,

What condition needs to be met on sheet2?

If it is just about being found, then take a look at the VLOOKUP formula.

Best regards,
Trowa
0