Hey Guys
I am working with a very large data set (over 10, 000 columns).
There are 100 unique values.
I have the latitude, longitude and altitude for 100 locations.
I want to add this information to my large dataset.
Basically I want to fill column B, C, D based on the value of column A.
But I have over 100 different options so need a fast way to do this please.
Thank you
Last edited by maddy.23; 06-16-2022 at 10:05 PM.
Can you give us a worksheet example please,
you can use lookup formula, but to make sure it fits please attach some example
Hi sultan I have attached an exmaple
I want to autofill column C,D,E in sheet13 from sheet 2 if source name matches DOes this make sense
I am not sure if this is that you want, but try it,
you can copy this to wsheet Sheet13 C2, and then just drag it to all the column you want.
Formula:
Please Login or Register to view this content.
Your version says "2102". I'm not sure what version that is - does it allow for the new array formulas? If so, you could try this in cell C2 and copy across:
=XLOOKUP($A$2:$A$9289,Table1[[Site]:[Site]],Table1[Lat],"Not Found",0)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks