find contents of ajoining cell


  1. donnylad
    Posts : 174
    microsoft windows 10
       New #1

    find contents of ajoining cell


    Hi all,,, I have a single column array and using vlookup to get a cell, and I need to know what the cell above it contains. Can you help please.
    Len
      My Computer
    Quote Quote

  3. cereberus
    Posts : 15,480
    Windows10
       New #2

    Easiest way is to copy the single column next to it but one row down

    e.g.

    Code:
    A
BA
CB
DC
 D
    Vlookup has to cover range of both columns, then use colum index as 2.
      My Computer
    Quote Quote

  4. donnylad
    Posts : 174
    microsoft windows 10
    Thread Starter
       New #3

    Thanks very much,,,that works for me.
    Len
      My Computer
    Quote Quote

 

  Related Discussions
Tethered cell only works once...
in Network and Sharing

Dell 7740, Windows 10 Pro (whatever MS just dumped on us), Moto G7 Power I'm currently using a Moto G7 Power on Visible (which uses Verizon towers) tethered for Internet (it's a long story, don't ask) I have NO idea if it's the phone or the...
I have a website backup in a gz file. In Windows 7, I could penetrate this file without, I'm pretty sure, any add-on software. I think 7's compressed file tools opened the .gz file fine, and then each subfolder and its contents and subfolders...
How do i set a table cell to autofill?
in Microsoft Office and 365

Hi TenForums community, I currently have a task at hand and i'm not too sure how to solve it. 272473 I would like to automate the rightmost column on the RISK Ratings based on Likelihood and Impact. For example, under Risk 1, if i were to...
Had this working last year on a different cell and number. YourPhone does not recognize the new cell. I am thinking that it is trying to link to the old one. The new cell has the APP installed and it says Your Phone And Pc Are Connected. What to...
Today I witnessed a most peculiar event on my Laptop. I had completely emptied my Software Distribution Folder and restarted. The Laptop downloaded the insiders evaluation build 18356 The total size of the download was around 4.35 Gigabytes but the...
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

 © Designer Media Ltd
All times are GMT -5. The time now is 20:37.
Find Us




Windows 10 Forums