- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Excel Help
Posted on 6/11/24 at 10:05 am
Posted on 6/11/24 at 10:05 am
OK so I have 2 spreadsheets.
I want to compare data in Column A on one sheet to Column B on a separate sheet, and when it matches pull data from Column C on the second sheet to Column B on the first sheet.
I am guessing some sort of V Lookup, but not my forte.
Thanks HP.
I want to compare data in Column A on one sheet to Column B on a separate sheet, and when it matches pull data from Column C on the second sheet to Column B on the first sheet.
I am guessing some sort of V Lookup, but not my forte.
Thanks HP.
Posted on 6/11/24 at 10:49 am to highpockets
=XLOOKUP(Sheet1!A1,Sheet2!B:B,Sheet2!C:C,,0)
This should do it.
This should do it.
Posted on 6/11/24 at 1:16 pm to BabySam
This.
ChatGPT or Gemini are great resources for having an Excel problem and either one of them providing a step by step solution.
ChatGPT or Gemini are great resources for having an Excel problem and either one of them providing a step by step solution.
Popular
Back to top
