How to perform vlookup and if condition in excel

Can anybody please help me with my requirement.
My requirement is to do an if condition based on which vlookup is to be done.
Lately I was doing this in macro but the requirements change and now I need to check if the pool is ANA then vlookup on it’s data is to be done and if it is Engine then vlookup on it’s data is to be done. Both are on same sheet and need to be populated on different sheet.

Can anybody please help me with this ??

Hi @Gloria,

Can you share your workflow file and I will try accordingly.
and the excel sheet (share some dummy data instead of original data) as well and different condition on which Vlookup is being done.

Regards,

Thank you Prassin for your reply.
It’s working now. :blush:

1 Like

Hi @Gloria,

Good to hear it worked.

try using @ symbol followed by the name of the person who you want to tag in your response :slight_smile:

Example @prassin6