Search for a certain value in column "A" and return its equivalent value from Column "B"

**christosf360** · 07-14-2024, 04:35 AM

Hi everyone, here is my challenge. I have a spreadsheet with various tabs. One tab contains a list of equipment, each row is a different piece of kit (different record). Column A contains each item's unique code and Column B contains its description. On a different tab of the same spreadsheet I need to be able to enter an item code in one cell (lets say A1) and somehow perform a search in the list of kit (on the other tab) and return its description on the cell next to it (let's say B1). I know I can not run a macro as part of a function in Excel. Any suggestions please as to how I could achieve this? Many thanks

**AliGW** · 07-14-2024, 04:39 AM

Administrative Note:

Welcome to the forum.

Is your forum profile showing the oldest Excel PRODUCT that you need this to work for?

Members will tailor the solutions they offer to the Office PRODUCT (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your product is for Mac, please also state this.

The three most recent Excel products are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the version number in your profile (e.g. MS365 Version 2306). This is in the About Excel section further down the Account page.

Thanks.

**AliGW** · 07-14-2024, 04:42 AM

Consider VLOOKUP:

https://support.microsoft.com/en-gb/...8-93a18ad188a1

Or, if you have Excel 2021 or 365, XLOOKUP:

https://support.microsoft.com/en-gb/...9-88eae8bf5929

YOu posted in the VBA section, but said that you could not run a macro - did you mean to post in the Formulas & Functions section? If so, I can move the thread for you.

**christosf360** · 07-14-2024, 04:56 AM

Ali hi, profile updated, thank you

**AliGW** · 07-14-2024, 04:57 AM

OK - thanks. See post #3 and lest me know how you get on. No need for macros for something as simple as this.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED. You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.

Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

**TMS** · 07-14-2024, 05:07 AM

Try, for example,

Formula:

Please Login or Register  to view this content.

**AliGW** · 07-14-2024, 05:32 AM

Gone without acknowledging any of the solutiuons offered.

Please see post #5 and sign off the thread accordingly. Thanks.

**bakerman2** · 07-14-2024, 06:10 AM

Instead of VLookUp still prefer Index-Match because of the flexibility.

Formula:

Please Login or Register  to view this content.

Search for a certain value in column "A" and return its equivalent value from Column "B"

LinkBack

Thread Tools

Rate This Thread

Display

Search for a certain value in column "A" and return its equivalent value from Column "B"

Re: Search for a certain value in column "A" and return its equivalent value from Column "

Re: Search for a certain value in column "A" and return its equivalent value from Column "

Re: Search for a certain value in column "A" and return its equivalent value from Column "

Re: Search for a certain value in column "A" and return its equivalent value from Column "

Re: Search for a certain value in column "A" and return its equivalent value from Column "

Re: Search for a certain value in column "A" and return its equivalent value from Column "

Re: Search for a certain value in column "A" and return its equivalent value from Column "

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Column X-Ref list - Sheet1 Col A "pages", Col B:FL "Req" to Sheet2 ColA "req", ColB "page"

compare cells from column "A" and return newest date from column "B"

Update Macro to search column Bfor "Fail" and "Exception"

[SOLVED] If there is any text in column "A$" on "sheet1" then move cell to column "A$" on "sheet2"

Pivot Table - How to "add a data column" "of the same field" "across multiple sheets"

[SOLVED] Find "X" in range of cells and return various values based on the column "X" is found in.

Search all rows on Sheet1 for cells in Column "C" that contain "PD" and if found cut

Bookmarks

Bookmarks

Posting Permissions