Formula in Data Validation Cell + Return Values if Match

**vill** · 10-03-2017, 01:18 PM

Hi guys, is there a way to write formula in cells where data validation is applied? Can't seem to find anything of such online... I tried my ways, and excel just wouldnt let write formula in those cells.

Also, as per file attached, would you be able to suggest what formula could be written in such cell, where basically: return values (currency symbol) if 2 names are matching from two different tabs.

All details are shared in excel file:

https://www.excelforum.com/attachmen...1&d=1507051099

Thanking you in advance!

**63falcondude** · 10-03-2017, 02:03 PM

I think that this is what you are looking for.

B3 of Tab 1 =INDEX('Tab 2'!B$4:B$7,MATCH(A3,'Tab 2'!A$4:A$7,0)) Drag this down through B6.

If you want to change the symbol using the drop-down, you can but it will remove the formula in that cell.

**Syrkrasi** · 10-03-2017, 02:06 PM

Originally Posted by vill

is there a way to write formula in cells where data validation is applied?

The answer is: yes. All you have to do is turn off (uncheck) Show error alert invalid data is entered

Originally Posted by vill

would you be able to suggest what formula could be written in such cell, where basically: return values (currency symbol) if 2 names are matching from two different tabs.

The answer is: yes. you could use Index Match: =INDEX('Tab 2'!$B$4:$B$7,MATCH(A3,'Tab 2'!$A$4:$A$7,0))

see attachment

**vill** · 10-03-2017, 02:41 PM

Guys, you are the best. And this forum is top class.

Thank you so much, for all your help!

**63falcondude** · 10-03-2017, 02:42 PM

Glad we could help.

If that solved your question, please mark this thread as SOLVED.

Thanks for the rep!

**vill** · 10-03-2017, 02:43 PM

PS: it is okay that formulas will be removed after changing currency manually, still works for what it needs to do. Thanks for a point, though!

**vill** · 10-03-2017, 02:44 PM

Marked as SOLVED :-)

Formula in Data Validation Cell + Return Values if Match

LinkBack

Thread Tools

Rate This Thread

Display

Formula in Data Validation Cell + Return Values if Match

Re: Formula in Data Validation Cell + Return Values if Match

Re: Formula in Data Validation Cell + Return Values if Match

Re: Formula in Data Validation Cell + Return Values if Match

Re: Formula in Data Validation Cell + Return Values if Match

Re: Formula in Data Validation Cell + Return Values if Match

Re: Formula in Data Validation Cell + Return Values if Match

Thread Information

Users Browsing this Thread

Similar Threads

Data Validation List - Formula to Sort and Return Unique Values in List

[SOLVED] Values not returned by Index, Match when using values from Data Validation

[SOLVED] Need Help Creating INDEX/MATCH Formula to Return Values from Data Table

[SOLVED] Return cell count based on multiple values (and data validation)

[SOLVED] Formula to match data ( multi column) in different sheets and return matching values

[SOLVED] Formula to match data in different sheets ( multi column) and return matching values

[SOLVED] Data Validation --> Return Multiple Values via VLookup from Dynamic Data

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions