Chosen value from a table to correspond to a specific entry

**Schalk** · 11-30-2020, 08:49 AM

Hi everyone, I knew how to do this long ago but now Im stuck.

If you look at Sheet 2, G2 must go find the value in A2 in the table on Sheet1. Then return the value in the top row on Sheet 1 of which column it finds the corresponding value. In this case, Sheet 2 G2 must be 'CCV82'

**KOKOSEK** · 11-30-2020, 09:00 AM

G2 on Sheet2:

Formula:

Please Login or Register  to view this content.

**Schalk** · 11-30-2020, 09:20 AM

Hi KOKOSEK, it says the formula contains an error

**KOKOSEK** · 11-30-2020, 09:34 AM

100% works. Try recopy more carefully.

	G	H
1	ALLOCATION	CHECKED
2	CCV82	7-Jan-19

	G	H
1	ALLOCATION	CHECKED
2	=INDEX(Sheet1!$1:$1,MATCH('Sheet 2'!A2,Sheet1!$2:$2,0))	7-Jan-19

**Schalk** · 11-30-2020, 10:10 AM

I tried several times its says error and when I click ok, it highlights the $1,MATCH part

**KOKOSEK** · 12-01-2020, 04:53 AM

That's probably difference between mine and yours regional settings (how to separate parameters of function)
Try:

Formula:

Please Login or Register  to view this content.

**Schalk** · 12-01-2020, 05:14 AM

This one works, thank you so much!

**Schalk** · 12-01-2020, 08:12 AM

what if I add a sheet 3 that must do the same as sheet 1, how will the formula change? I tried but sheet 3 still returns the same values as sheet 1

**KOKOSEK** · 12-01-2020, 11:24 AM

Here:

Formula:

Please Login or Register  to view this content.

Sheet1 - contains data to check
Sheet2 - where do you want to display results and also where parameter is located (in A2)
so if you want tot use this formula on Sheet3 put Sheet3 in place of Sheet2

Chosen value from a table to correspond to a specific entry

LinkBack

Thread Tools

Rate This Thread

Display

Chosen value from a table to correspond to a specific entry

Re: Chosen value from a table to correspond to a specific entry

Re: Chosen value from a table to correspond to a specific entry

Re: Chosen value from a table to correspond to a specific entry

Re: Chosen value from a table to correspond to a specific entry

Re: Chosen value from a table to correspond to a specific entry

Re: Chosen value from a table to correspond to a specific entry

Re: Chosen value from a table to correspond to a specific entry

Re: Chosen value from a table to correspond to a specific entry

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to calculate total time-intervals that correspond to a specific criterion

Require a specific textbox to be filled only if a specific answer from a listbox is chosen

[SOLVED] Delete fields that correspond to certain months in amortization table

[SOLVED] Excel 2003 Counting how many data cells correspond to a specific cell (Person's Name)

[SOLVED] 2 specific secondary drop down lists can be chosen after chosen specific option in primary

Automatic entry from outlook automatically copieo specific table in Access.

Looking up specific values which correspond to a number

Bookmarks

Bookmarks

Posting Permissions