LOOK UP DATA FROM EXCEL

Anonymous
2020-12-19T05:19:41+00:00

Hi there!

Would someone help me out there... here below an example: 

There are more than a ten thousand of Lucky Draw Tickets sold out with First name registered under the excel file - Column A & B (below screen shot just captured part of the data) . The Lucky Draw Winner result has now been ready with ticket no. under column E. 

Is there any excel function set up that I can apply for in order to get First name out in a quick and easy way rather than using filter to check one by one. 

Thank You! 

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2020-12-19T06:51:33+00:00

Hi

Please try this formula in cell F2 and fill it down 

=VLOOKUP($E2,$A:$B,2,FALSE)

Regards 

Jeovany

Was this answer helpful?

1 person found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-12-19T11:19:16+00:00

    Hi Jeovany CV, 

    Thanks for your prompt feedback to solve the issue.  :)

    Was this answer helpful?

    0 comments