I am trying to auto populate the cells on sheet 1 columns F & H based on the selection of Column C.
The corresponding data is on the data tab. Column G and I match up with their respective equipment in Column E.
I thought this was starting with a VLookup and Item Num and just got lost. I believe I am overthinking this.
Any suggestion or help is much appreciated.
What influence does Column A have on the output?
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Hi,
Column A has no influence on the output, it is simply there to provide the dropdown data for banking center that I can easily add to or delete from.
Formula for F3 =IF([@[Equipment Type]]="","",INDEX('Sheet 3'!G:G,MATCH([@[Equipment Type]],'Sheet 3'!E:E,0),1))
Formula for H3 =IF([@[Equipment Type]]="","",INDEX('Sheet 3'!I:I,MATCH([@[Equipment Type]],'Sheet 3'!E:E,0),1))
Thank you very much, mehmetcik. Sorry to be so green. When I add these formulas in, I get a "Value not available error". Should I be adding anything between the "","",?
Thanks again for you assistance.
Sample attached.
Thank you so much for your help. Have a great weekend!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks